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

256 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
complex203724(None) 
comped135919872comp_ed
compeer133811552compeer
compel124412892comp_el
compels133210892compels
compile13312442compile_
compiled1537812compiled
compiler1438372compiler
compiles14311982compiles
compleat14710152compleat
complect1659012complect
complete143412052complete
complexed23295982complexed
complexer22316212complexer
complexes22308112complexes
complexly2543072complexly
complied1539672complied
complier14310252complier
complies14314522complies
complin13312072complin
complot13310682complot
comply152810382compl_y
compted143813522compted
couple104415962couple_
coupled124312672coupled
coupler114713012coupler
couples115317052couples
couplet114717942couplet
simplex18256392simplex
ample94720303_ample_
ampler104313303_ampler
bomblet13412263bomblet
camlet104426583cam_let
camped134720233camp_ed
camper124722213camp_er
campier133313273campier
caplet104226813c_aplet
chaplet14512253chaplet
chomped17329773chomp_ed
chomper163810073chomp_er
cimex16119133cim__ex
clomped14398973clomp_ed
coaled95022713co_aled
coaler84121713co_aler
coannex1635513coannex
coapted123911503coapted
cobble123615263cobble_
cobbled143411633cobbled
cobbler133311823cobbler
cobbles133814823cobbles
coble94823173co_ble_
cobles104622883co_bles
cochlea1435343cochlea
cockle143913573cockle_
cockled163710823cockled
cockles153414643cockles
coddle104713853coddle_
coddled123410573coddled
coddler113710833coddler
coddles114213593coddles
codex155817583co__dex
coemploy1743323coemploy
coempted1535333coempted
coffle14359043coffle_
coffled16297363coffled
coffles152610003coffles
coiled95123943co_iled
coiler84421593co_iler
cole66956113co__le_
coled85540763co__led
coles76055063co__les
collet84030363co_llet
comade114415323comade_
comae97128423com_ae_
comake144413423comake_
comaker153410603comaker
comakes154413643comakes
comal95125133comal__
comate104124843comate_
comates114123643comates
combe116223543com_be_
combed135516543com_bed
comber125118503com_ber
combes125321733com_bes
come87547703com__e_
comelier12310653comelier
comely134213733comel_y
comer95832693com__er
comes97246993com__es
comet95946073com__et
comfier1439163comfier
comfrey1734683comfrey
comix163513203com__ix
commie124215523commie_
commies133718453commies
commix19407763com_mix
comose105016853comose_
comp106731253comp___
compact153712213compact
company1619711143company
compare135814993compare
compared153811823compared
comparer143611363comparer
compares143816433compares
compart134016003compart
compas125817063comp_as
compass13379563compass
compeers143410013compeers
compelled1646133compelled
compeller1546293compeller
compend144010303compend
compere134616623compere
compered153414923compered
comperes143217973comperes
compete134716553compete
competed154113593competed
competes144117243competes
compilers1537053compilers
comping143518593comping
complain1448763complain
complects1766413complects
completed162810273completed
completer153310413completer
completes153212923completes
complexest23265593complexest
complexify2952293complexify
complexing2444743complexing
complexion2343753complexion
complexity2653433complexity
complice1639333complice
complices1739253complices
compliers1538293compliers
compline14313553compline
complines15312833complines
complins14313113complins
complots1438163complots
compo115318573comp__o
compone136517193compone
compony1613011913compony
comport133616843comport
compos124818803comp_os
compose135716663compose
composed154612063composed
composer145012953composer
composes145017123composes
compost134515353compost
compote135616463compote
compotes144716513compotes
compress1439053compress
comps115526053comp__s
compt116328223comp__t
compts125216653comp_ts
compute134513663compute
computed154110953computed
computer144511513computer
computes143914553computes
comte96125473com_te_
comtes106222813com_tes
conflux1943003conflux
convex18367743co_nvex
cooled95224593co_oled
cooler84824713co_oler
cooped114821603coop_ed
cooper104221123coop_er
coopted123710763coopted
cope86847383co_p_e_
coped105036843co_p_ed
copen94826433co_p_en
coper95336093co_p_er
copes97747103co_p_es
copied114618563co_pied
copier103722893co_pier
copies104130303co_pies
coplot10518273co_plot
copped135221253co_pped
copper124321893co_pper
copse95623923co_pse_
copses104922473co_pses
copter109822013co_pter
corpse104013403corpse_
corpses113913803corpses
corslet9318063corslet
cortex15311473co_rtex
coruler9311713coruler
coulee8323513co_ulee
coupe96023483coup_e_
couped115019313coup_ed
coupes105022523coup_es
couplers123311323couplers
couplets12389873couplets
cowled125218393co_wled
cowpea1337643cowp_ea
cowpie133511513cowpie_
cowpies143314283cowpies
cowplop1643363cowplop
cowpox2035003cowp_ox
crimple13408693crimple_
crimpled15366933crimpled
crimples14308963crimples
crumple13368363crumple_
crumpled15296873crumpled
crumples14348813crumples
culex144613933c__ulex
dimple113512793dimple_
dimpled132810303dimpled
dimples122813213dimples
diplex16408053_diplex
duplex16386973_duplex
fourplex2042093fourplex
funplex1932833funplex
homosex1936133homosex
hopple132910483hopple_
hoppled15338083hoppled
hopples142810713hopples
impled113812513_impled
nombles113212343nombles
noncomplex2352773noncomplex
octuplex1942183octuplex
omelet8317073_omelet
perplex1836153perplex
pimple123512963pimple_
pimpled14289193pimpled
pimples133012423pimples
plex137321373___plex
pollex153711163po_llex
popple92710983popple_
poppled11339243poppled
popples103011873popples
rimple103814583rimple_
rimpled123311423rimpled
rimples113114223rimples
romped114513653romp_ed
romper104213683romp_er
rumple103913013rumple_
rumpled123810013rumpled
rumples113313133rumples
sample104215013sample_
sampled123410793sampled
sampler113212013sampler
samples112815453samples
scolex1538243sco__lex
semple103212753semple_
simple104315173simple_
simpler112910863simpler
simples113014943simples
temple102811333temple_
templed12278563templed
temples112610893temples
templet112712003templet
topple104411323topple_
toppled12348843toppled
topples113111653topples
triplex16447803triplex
wimple133611363wimple_
wimpled15338823wimpled
wimples143311173wimples

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.453394461.4
2DLD Change Limit1340272567.18618651.1
3Display Results2562560.0932752.7
 (SQL Overall)1786912567.73223110.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.