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

226 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
chimera1438927(None) 
chimaera1564941chimaera
chimer135517201chimer_
chimeras15388831chimeras
chimere144010631chimere
chimers144515141chimers
camera10313692c_amera
chicer134513602chicer_
chider125116052chider_
chiders135312942chiders
chimaeras1664572chimaeras
chimar133911472chimar_
chimars144010592chimars
chime125322592chime__
chimed145814832chime_d
chimeres153511312chimeres
chimeric1746742chimeric
chimes134922572chime_s
chimla1337592chim_la
cholera12409092cholera
achier113914263achi_er_
ahimsa1134783ahim_sa
aimer75926823_aimer_
aimers84621913_aimers
cahier113615773cahi_er_
cahiers123510673cahi_ers
caldera1037963caldera
calmer105216933calmer_
camerae11312063c_amerae
cameral11311283c_ameral
cameras11313363c_ameras
casimere1254793casimere
ceiler84013963ceiler_
ceilers93912533ceilers
chaeta11310683ch_aeta
chafer144714573chafer_
chafers154512743chafers
chakra15437533ch_akra
chamber164011063chamber_
chambers173410623chambers
chambray2043143chambray
chamfer17399863chamfer_
chamfers18409223chamfers
chamisa14328853chamisa
champer163813413champer_
champers173311623champers
charmer144913663charmer_
charmers154211333charmers
chaser114918383chaser_
chasers123714923chasers
chawer144314413chawer_
chawers154412053chawers
cheder125113493cheder_
cheders134512393cheders
cheer105420383ch_eer_
cheero114712943ch_eero
cheers114518913ch_eers
cheery144913153ch_eery
chela103916803ch__ela
chelicera1642883chelicera
chert105232103ch__ert
chewer145512623chewer_
chewers154111143chewers
chia96026623chi___a
chiasma14366993chiasma
chica125818263chi__ca
chicest14209943chicest
chicory1735993chicory
chide115321023chide__
chided135113963chide_d
chides124620473chide_s
chief134419483chi_e_f
chiefer1536863chiefer_
chiefs14509653chi_efs
chiel104918973chi_e_l
chield124610213chi_eld
chiels115115933chi_els
chigetai1443233chigetai
chigger1436003chigger_
chiggers1535563chiggers
chile105626893chile__
chiles115425303chile_s
chiller124112183chiller_
chillers133710923chillers
chimaeric1844333chimaeric
chimb144813563chim__b
chimbly1974593chimbly
chimbs153910303chim_bs
chimerical1954543chimerical
chimerism1854953chimerism
chiming153311833chiming
chimlas1437453chimlas
chimley1785163chimley
chimleys1883633chimleys
chimney1795483chimney
chimneys1883643chimneys
chimp145216473chim__p
chimps155713663chim_ps
china105022483chi__na
chine105231723chine__
chined125620063chine_d
chines115029173chine_s
chipper163912583chipper_
chippers173510883chippers
chiral114614413chi__ral
chirk144516183chi__rk
chirker16429323chirker_
chirm125317063chi__rm
chirmed15379733chirme_d
chiro105320343chi__ro
chirp124717163chi__rp
chirper14359963chirper_
chirpers15358133chirpers
chirr105015903chi__rr
chirre114111853chi_rre
chirred133612123chirred
chirren12388743chirren
chirres123812253chirres
chirrs114514983chi_rrs
chiru105317153chi__ru
chisel112111943chise_l
chisels12219103chisels
chitter124112963chitter_
chitters133711173chitters
chivari1536043chivari
chive135117623chive__
chives144317593chive_s
choicer14197893choicer_
choker154314373choker_
chokers164311523chokers
choler113717153choler_
choleras13289043choleras
cholers124215203cholers
chomper163810073chomper_
chompers17369593chompers
chorea115216093chore_a
chyme156512503chyme__
chymes165912153chyme_s
cicero1048503c_icero
cider84723323c_ider_
ciders94620093c_iders
cimex16119133c_ime_x
cinema1047653c_inema
citer74827333c_iter_
citers85022983c_iters
claimer11279883claimer_
claimers12298743claimers
climber13449133climber_
climbers14318413climbers
clime95720893clime__
climes104720003clime_s
clivers123411753clivers
cocinera1245553cocinera
coiler84421593coiler_
coilers93619903coilers
coiner84323783coiner_
coiners93620753coiners
comer95832693c_omer_
comers105328083c_omers
crier74724463cri_er_
criers83918583cri_ers
crime94822693crime__
crimes105521583crime_s
crimmer133310773crimmer_
crimmers14298543crimmers
crimper136510423crimper_
crimpers14318933crimpers
criteria1048013criteria
cummer124414593cummer_
cummers133713483cummers
dimer85625603_dimer_
dimers94321093_dimers
ephemera1554213ephemera
epimer10109153epimer_
epimere1186983epimere
epimers11109493epimers
glomera1035943glomera
hider95024093_hider_
hiders104919653_hiders
hijra1535643_hi_jra
hiker125119393_hiker_
hikers135014353_hikers
hirer85423123_hirer_
hirers94518063_hirers
homer105828453_homer_
homers114821983_homers
humeral1238573_humeral
humeri1138523_humeri
maimer104514593maimer_
maimers113813043maimers
mimer94825763_mimer_
mimers105520183_mimers
philtra12103683philtra
primer105118683primer_
primero11368923primero
primers114215673primers
rhymer14387083rhymer_
rhymers15365543rhymers
rimer75429243_rimer_
rimers84522553_rimers
schemer1477963schemer_
schemers1576713schemers
schmear1484043sch_mear
shier85428943shi_er_
shiers94921753shi_ers
shimmer143310873shimmer_
shimmers15269413shimmers
shimmery18265253shimmery
shiner93820873shiner_
shiners104015943shiners
shiver124517373shiver_
shivers133714833shivers
shivery16317023shivery
shmear1176933sh_mear
timer75626043_timer_
timers84420993_timers
trimer85717153trimer_
trimers94615143trimers
whimper17297723whimper_
whimpers18276613whimpers
whiner124516633whiner_
whiners134011573whiners
whiter124316393whiter_
womera11137593_womera
wommera14144063wommera
woomera12135773woomera

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.406440125.6
2DLD Change Limit1340272266.73319906.0
3Display Results2262260.0802825.0
 (SQL Overall)1786912267.21924752.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.