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

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

88 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
copilot1181126(None) 
copilots1255751copilots
coplot10518271cop_lot
complot13310682complot
coplots11511592cop_lots
pilot77435062__pilot
autopilot1154243autopilot
capelet11517073capelet
capitol11258283capitol
caplet104226813cap_let
challot123613263challot
chalot113020133c_halot
clot66542423c___lot
cobalt10317393cobal_t
cockloft1945693cockloft
coelom10310433co_elom
cogito939203cogito_
cogitos1037613cogitos
coil66439653co_il__
coiled95123943co_iled
coiler84421593co_iler
coils75030083co_il_s
collet84030363co_llet
collop107312313co_llop
colog86619933co__log
colon78630193co__lon
color76123743co__lor
colt67158243co__l_t
compile13312443compil_e
compiled1537813compiled
compiler1438373compiler
compiles14311983compiles
complots1438163complots
coot67860383co___ot
copal95621783copal__
copalm125010813copal_m
copalms13367543copalms
copals105018943copal_s
copepod1444853copepod
copied114618563copi_ed
copier103722893copi_er
copiers114215963copiers
copies104130303copi_es
copihue1444143copihue
coping113927663copi_ng
copings124111843copings
copious11311963copious
copout10418783cop_out
copula102812043copul_a
copulae112810613copulae
copular113810603copular
copulas113811563copulas
copulate122614113copulate
copyboy1963513copyboy
copycat1647593copycat
copyist1439053copyist
copyleft1843983copyleft
corslet9318063corslet
cosiest93819853cosiest
cosily113613853cosil_y
cotillon1045053cotillon
couplet114717943couplet
cowflop1742893cowflop
cowiest123614673cowiest
cowplop1643363cowplop
coziest184014353coziest
cozily20349703cozil_y
dopiest103315993dopiest
dopily123510463dopil_y
epilog976463_epilog
gyropilot1552393gyropilot
melilot9311083melilot
mopiest113014293mopiest
ocelot8813383_ocelot
picot95031013__picot
pilots84018873__pilots
pinot78737293__pinot
pivot106523873__pivot
plot66141233__p_lot
replot83818593rep_lot
ropiest93317773ropiest
ropily113312443ropil_y
spigot9312603_spigot
spilt75532223_spil_t
spoilt85016593spoil_t
toilet66228093to_ilet
topknot1346423topknot
woodlot1147023woodlot

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 Filter1786911340270.406440125.6
2DLD Change Limit134027886.00022337.8
3Display Results88880.0302933.3
 (SQL Overall)178691886.43627764.3
 
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.