Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “image” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

72 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
image8141129(None) 
imaged1097761imaged
imager9108121imager
images91411461images
imago8118691imago
mage75739131_mage
adage7414052adage
age47154332__age
amaze166016602amaze
ambage11510602ambage
cage75339062_cage
damage10410772damage
gage65936102_gage
homage121210602homage
imagers10107762imagers
imagery13124202imagery
imagine1037882imagine
imagoes10126402imagoes
imagos9117552imagos
imam81718332ima_m
imams91511112imams
imaret81121232imaret
imaum9139642imaum
imbue939482imbue
imide85716892imide
imine75821062imine
immane1038882immane
impale102811662impale
inane52820342inane
incage93513622incage
inmate82917362inmate
innage73011572innage
irade65618152irade
irate55627982irate
linage7713402linage
mabe85733362_mabe
mace87345792_mace
made75440242_made
mae57659112_ma_e
mag67956482_mag_
mages85036022_mages
magi76329532_magi
mags75444532_mags
make105537892_make
male66052302_male
mane65052032_mane
mange84930192_mange
mare64759332_mare
marge85328332_marge
mate65154222_mate
maze155434982_maze
midge95016552midge
milage93414122milage
mirage92313652mirage
ohmage1295062ohmage
page76036102_page
peage84723572peage
phage115113672phage
pipage1199142pipage
plage84520402plage
primage12169142primage
rage55742352_rage
reimage1037912reimage
rivage1038842rivage
sage55044592_sage
silage72715302silage
smaze165012932smaze
stage65330192stage
swage94919562swage
usage6410212usage
visage1049082visage
wage84834082_wage

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.360496363.9
2DLD Change Limit53800721.90628226.7
3Display Results72720.0164500.0
 (SQL Overall)178691722.28278304.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.