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 “geometer” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
geometer113842(None) 
geometers1238191geometers
aerometer11410202aerometer
biometer1239602biometer
gasometer1267082gasometer
geometry1445392geometry
odometer1147412odometer
orometer10310702orometer
pedometer1447732pedometer
rheometer1446092rheometer
udometer1146332udometer
aerometers1249483aerometers
algometer1246533algometer
ammeter1148393_ammeter
anemometer1444843anemometer
atmometer1346203atmometer
barometer13189043barometer
biometers1339173biometers
bolometer1348213bolometer
ceilometer1445433ceilometer
cementer1239193ce_menter
cemetery1554923ce_metery
comether1537253_comether
coveter122912063_coveter
cryometer1646433cryometer
decameter14137363decameter
decimeter14147413decimeter
deemster1175713deemster
dekameter16135103dekameter
depleter11298853depleter
diameter1148053diameter
dimeter10411893_dimeter
doomster1135843doomster
durometer1246443durometer
emeer74815363_e_me_er
emoter85415193_e_moter
ergometer1246153ergometer
fermenter1497543fermenter
ferreter1136543ferreter
flowmeter1743393flowmeter
fomenter1339263_fomenter
gamester1137323g_amester
gamete9313593g_amete_
gametes10312253g_ametes
gasometers1346643gasometers
geezer16278013ge__ezer
gemmate12418383gemmate_
gemmated14336293gemmated
gemmates13307673gemmates
gemmier12337383ge_mmier
gemote94613023ge_mote_
gemotes103712143ge_motes
geodetic1246323geodetic
geologer1044483geologer
geomancer1443753geomancer
geometric14158313geometric
geometrid13156323geometrid
geometries13139253geometries
germier10309543germ_ier
getter74117613ge__tter
gloater83711013glo_ater
goiter74116203g_o_iter
gomer85220653g_om__er
gomerel1036393g_omerel
goniometer1344933goniometer
greeter82812673g_reeter
grommeted1553163grommeted
grouter84412523gro_uter
groveler12305843groveler
hectometer1746413hectometer
heliometer1546303heliometer
helmeted1435833helmeted
hexameter2144853hexameter
hygrometer1994623hygrometer
kilometer1576933kilometer
manometer1368763manometer
meeter83616503me__eter
meter75130323___meter
monometer1349933monometer
nanometer1167783nanometer
odometers1247133odometers
ohmmeter1543613ohmmeter
optometer1347293optometer
orometers11310423orometers
osmometer1345203osmometer
oximeter1755153oximeter
pedometers1547213pedometers
perimeter1349553perimeter
picometer1548913picometer
piezometer2343753piezometer
potometer1349843potometer
promoter12311453promoter
prompter1437983prompter
pyrometer1648883pyrometer
remoter94815973re_moter
rheometers1545753rheometers
salometer1188693salometer
seamster1037143seamster
secreter1038503secreter
semester1038903se_mester
teamster1036293teamster
teeter65420313te__eter
telemeter1147283telemeter
tempter11358213te_mpter
tonometer1148293tonometer
trimeter10310083trimeter
udometers1245743udometers
vomiter1237953_vomiter
whomever1942963whomever
yawmeter1693873yawmeter
zymometer25847353zymometer

Search took 7 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621116.76621602.4
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.96825644.5
 
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.