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 “germier” 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.

460 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
germier1030954(None) 
gemmier12337381gemmier
aerier64823152aer_ier
barmier114313042barmier
beamier113411942beamier
dernier83011942dernier
eerier64320022eer_ier
elmier839812_elmier
fernier103110822fernier
gamier93617932g_amier
gammier123711192gammier
geekier12286392geekier
germen9612312germ_en
germiest11249912germiest
germina1038492germina
girlier8289522girlier
gleamier1144912gleamier
gorier73719372gor_ier
gorsier83811072gorsier
grimier103210432grimier
gummier12349472gummier
herbier1239592herbier
jerkier18407272jerkier
merrier92612302merrier
nerdier83110352nerdier
nervier10298832nervier
perkier133813122perkier
premier113515632premier
seamier93114632seamier
termer85717252term_er
terrier73414962terrier
verier94620962ver_ier
vernier102711272vernier
wormier12278762wormier
aerie54634603aer_ie_
aeried74221863aer_ied
aeries64737783aer_ies
airier64619363air_ier
armer76924443_arm_er
armies85123693_armies
armiger1036253_armiger
artier63419733_artier
balmier113811513balmier
barkier133814483barkier
barmie103816393barmie_
barnier93213673barnier
barrier94017733barrier
beadier103513913beadier
beakier134012163beakier
beefier12329093beefier
beerier93613023beerier
belier84423563be_lier
bemire103312803be_mire
bendier103111413bendier
berime105317333berime_
berimed124912283berimed
berimes115216643berimes
berme96022943berm_e_
bermed115217723berm_ed
bermes106023003berm_es
berming123614833berming
berried103714043berried
berries94423553berries
boomier113312183boomier
brevier1237763brevier
brier74527403_br_ier
burier84324653bur_ier
burlier93514413burlier
burrier93613553burrier
carrier93619583carrier
cermet10321153cerm_et
chertier1387873chertier
chromier1538033chromier
corkier133114303corkier
cornier93017093cornier
creamier12319063creamier
crepier1139733crepier
crier74724463_cr_ier
curdier103312623curdier
curlier93314183curlier
currier93316703currier
curvier123110663curvier
decrier102713553decrier
deedier93011593deedier
defier105118653de_fier
deifier113013123deifier
demies94825803de_mies
denier74420693de_nier
derbies103016053derbies
derider93214973derider
deriver114213913deriver
dermic114511913dermi_c
dermis94717163dermi_s
dermises112512023dermises
derriere936043derriere
derries83124623derries
dewier104013463de_wier
dirtier83312093dirtier
doomier103610123doomier
dorkier122810023dorkier
dormer94415903dorm_er
dormie9312623dormie_
dreamier11287293dreamier
drier64423963_dr_ier
earlier72612743earlier
easier64218463_easier
edgier8469723_edgier
eelier64216463_eelier
eerie55228533eer_ie_
ember95516803_e_mber
emeer74815363_e_meer
emir65918703_e_mi_r
emmer94314463_e_mmer
envier939673_envier
epimer10109153_epimer
eraser64216333_eraser
ermine8416923_ermine
ermined10410603_ermined
ermines9416673_ermines
farmer115017373farm_er
farrier103514893farrier
fennier10339253fennier
ferlie92814053ferlie_
ferlies103216693ferlies
fermi103914163fermi__
fermion1236763fermion
fermis114313503fermi_s
fermium1446353fermium
ferried113411523ferried
ferries103521083ferries
fierier103511193fier_ier
filmier1237503filmier
firmer114712443firm_er
firrier103410133firrier
flamier123112143flamier
foamier12339003foamier
forkier144311593forkier
former114221403form_er
frier85225843_fr_ier
fumier11310903_fumier
furrier103513663furrier
furzier19318103furzier
gabbier12379633gabbier
gambier124711973gambier
gamer84928943g_am_er
gammer1112318333g_ammer
gappier12369843gappier
garbler104012563garbler
gargler93710263gargler
garner73917003gar_ner
garter74420513gar_ter
gassier83812573gassier
gaudier938453gaudier
gauzier1735633gauzier
gawkier15326523gawkier
geezer16278013ge_ezer
gelder84613713ge_lder
gemmae11507793gemmae_
gemmed12329573ge_mmed
gemmiest13227623gemmiest
gemmily1534603gemmily
gemming13289143gemming
gender83517933ge_nder
genie66124923ge_nie_
genies75324943ge_nies
gentler8378953gentler
geometer1138423geometer
gerbera1034773ger_bera
gerbil938343gerbi_l
gerbils1037303gerbils
germ75428963germ___
german9611983germ_an
germander1345363germander
germane1049663germane
germans1079473germans
germens1078623germens
germfree1442683germfree
germinal1147253germinal
germiness1257693germiness
germlike1535093germlike
germs85118873germ__s
germy115113663germ__y
getter74117613ge_tter
geyser1036513ge_yser
giddier10308723giddier
gimmie11298183gimmie_
gimmies123010113gimmies
gimpier12247943gimpier
ginnier8298983ginnier
girder84312063gir_der
girdler9227313girdler
girlie73711463girlie_
girlies83013703girlies
glacier103911293glacier
gladier93810993gladier
glarier84112203glarier
glazier17409353glazier
gleamer10328513gleam_er
gleetier934913gleetier
glimmer12437713glimmer
gloomier1135093gloomier
gluier7310263g_luier
glummer12417983glummer
glumpier1334873glumpier
gnarlier9255163gnarlier
godlier938893godlier
gomer85220653g_om_er
goofier11339313goofier
gooier73516213g_ooier
goonier83612843goonier
goopier103910573goopier
goosier83512563goosier
gorger86116983gor_ger
gormed105013833gorm_ed
gorming112810833gorming
goutier82612353goutier
grader84919693g_rader
grainer83714063g_rainer
grapier103712603grapier
grater74625443g_rater
graver105018593g_raver
grayer106014543g_rayer
grazer164815763g_razer
grazier173611133grazier
greaser83913083greaser
greasier9298083greasier
greater84416493greater
greedier1036083greedier
greener83111713greener
greenier938713greenier
greeter82812673greeter
gremial1039153gremial
gremmie1264383gremmie_
gremmies1355993gremmies
greyer104510093g_reyer
grief95319783g_r_ief
grime85021323g_rime_
grimed104714093g_rimed
grimes94619033g_rimes
grimmer123510093grimmer
griper94114613g_riper
gripier103210323gripier
grocer94212143g_rocer
grodier939673grodier
groper94517253g_roper
grower104614933g_rower
grummer12338783grummer
grumpier1334803grumpier
gulfier1137793gulfier
gulpier1046953gulpier
gummer114615453g_ummer
gunkier12369553gunkier
gurries83515953gurries
gushier113110073gushier
gustier83813863gustier
gutsier8389823gutsier
guttier83911103guttier
hammier143510653hammier
hardier114721543hardier
harmer114719553harm_er
harrier104417753harrier
headier113212953headier
heartier1139093heartier
heavier13429423heavier
hedgier12367873hedgier
heftier1337203heftier
hemmer134112643he_mmer
hempier14319003hempier
herder104516463her_der
hermae115314473hermae_
hermit11519443hermi_t
hermitry1644453hermitry
hermits12312143hermits
herried113514453herried
herries104025073herries
homier116416993_homier
hornier103012463hornier
horsier103013243horsier
hurrier103412943hurrier
jammier18408023jammier
jemmied19294483jemmied
jemmies18318333jemmies
jerker17369043jer_ker
jerkies183411583jerkies
jerries143817513jerries
jettier14358693jettier
kermes124616123kerm_es
kermis124012393kermi_s
kermises14248313kermises
kerries113317913kerries
lardier83518343lardier
larkier113711523larkier
leadier83212723leadier
leafier10329833leafier
leakier114010993leakier
learier73415663learier
leavier10319993leavier
ledgier9458493ledgier
leerier73111503leerier
leggier9368233leggier
levier94013873le_vier
limier83518723_limier
loamier9349163loamier
lorimer937753lorimer
malmier113611953malmier
marlier92614773marlier
marrier93817523marrier
mealier93015903mealier
meatier93214613meatier
member12258853me_mber
mercer105214203mer_cer
mercies113817563mercies
merer75126233mer__er
merger95016473mer_ger
mermen10813813merm_en
meshier123410853meshier
messier93412923messier
metier83517693me_tier
mirier83918363mir_ier
mirkier13319053mirkier
murkier133110273murkier
nearlier836793nearlier
needier84010623needier
nettier74211813nettier
newsier10147223newsier
onerier7311613oner_ier
orbier839993_orbier
ormer75218373_orm_er
palmier113312173palmier
parrier93717653parrier
partier93520713partier
peakier134411443peakier
pearlier1037323pearlier
peatier94017233peatier
peckier153910523peckier
peppier10268323peppier
percher143313423percher
perdie94718513perdie_
permed115217343perm_ed
permian112612283permian
perming123416093perming
permit10321683permi_t
permits11314003permits
permitter1345963permitter
perries93226603perries
perter84422283per_ter
peruser93511373peruser
peskier13319113peskier
pestier94317403pestier
pettier94213613pettier
plumier113510043plumier
porkier133712343porkier
pornier93413133pornier
premie103617993premie_
premiere12249233premiere
premiers122911653premiers
premies113823063premies
prier75027763_pr_ier
primer105118683_primer
pursier94012753pursier
purtier93214093purtier
querier16310013quer_ier
rammier112811023rammier
readier83117423readier
reamer84325213ream_er
recamier1237603recamier
reedier83815303reedier
reefier102912553reefier
reekier113111123reekier
reifier103414523reifier
relier65826183re_lier
rentier73618223rentier
replier94214973replier
rheumier1342513rheumier
rimer75429243__rimer
rimier83916273_rimier
roomier93812243roomier
rummier11309563rummier
sarkier113413313sarkier
seamer84223613seam_er
sedgier9399043sedgier
seedier83513633seedier
seemer84418043seem_er
seemlier1035193seemlier
seepier92912013seepier
serener73415753serener
serer55935503ser__er
serger73819733ser_ger
series64540973ser_ies
serried82513963serried
serries73925353serries
server94917713ser_ver
servicer1335263servicer
sexier13310683se_xier
slimier93212013slimier
smarmier1235033smarmier
sorrier72313733sorrier
sprier84119063spr_ier
spumier1137903spumier
steamier1048303steamier
stemmier1245253stemmier
stormier1036103stormier
surfier102613543surfier
surlier72915443surlier
surmiser1036763surmiser
tardier859719993tardier
tarrier74323173tarrier
tarsier74119253tarsier
tartier74123263tartier
tearier73815613tearier
techier1269243techier
teemer85515743teem_er
teenier72611143teenier
temper103914093te_mper
tentier73815923tentier
termed94816703term_ed
termers95414503term_ers
terming104016003terming
termini93410813termini
termite9313893termite
termites10313693termites
termor84412513term_or
terriers84210823terriers
terries73425633terries
terser67317823ter_ser
testier74015643testier
thymier1534393thymier
trier54328533_tr_ier
trimer85717153_trimer
turfier10249793turfier
varier94619353var_ier
vealier102712173vealier
veinier10269583veinier
verditer1236223verditer
verger104315693ver_ger
verifier14159203verifier
vermeil1285223vermeil
vermes115019143verm_es
vermian12329713vermian
vermin113414523vermi_n
vermis114214963vermi_s
verniers11227843verniers
verser94516963ver_ser
warier93722893war_ier
warmer113816733warm_er
wartier103413913wartier
wearier103613283wearier
webbier1445423webbier
wedgier12428273wedgier
weedier113810623weedier
weenier103210803weenier
weepier12319273weepier
wennier10318603wennier
wirier94215553wir_ier
wordier112511213wordier
wormer114514913worm_er
worrier102311683worrier
wrier84521753_wr_ier
yummier14306843yummier
zestier163010223zestier

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274606.68620045.9
3Display Results4604600.1562948.7
 (SQL Overall)1786914606.99825534.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.