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

141 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
compiling163776(None) 
coiling103723452co__iling
combining1637892combining
commixing2345192commixing
comparing162410582comparing
compelling1746552compelling
compering163414162compering
competing163712462competing
comping143518592comp__ing
complin13312072comp_lin_
compline14313552comp_line
complins14313112comp_lins
complying1936112complying
composing16179842composing
comprising1748632comprising
comprizing2647462comprizing
compting153013602comp_ting
computing16309852computing
coppicing1845402coppicing
coupling13310782coup_ling
recompiling1843992recompiling
boiling103819673bo__iling
camping143118973camp__ing
campusing1654913campusing
caviling14310113c_aviling
ceiling103416723c__eiling
chomping18339883chomp__ing
clomping15329653clomp__ing
coaling103722823co__aling
coapting133511613coap_ting
cobbling15248803co_bbling
cockling172310393co_ckling
coddling13258473co_ddling
codling114418953co__dling
codriving1645213codriving
coediting1338333coediting
coempting1636073coemp_ting
coffining1845483coffining
coffling1736483co_ffling
cognising1347043cognising
cognizing2247173cognizing
coifing133213893co__ifing
coining103920543co__ining
cojoining1945753cojoining
colliding1338583colliding
comaking1739993com_aking
combating16310163combating
combing143714733com__bing
coming114225453com___ing
comingling1643373comingling
commingling1952823commingling
committing1746683committing
commoving1944983commoving
communing16207863communing
commuting16288443commuting
compacting19177093compacting
companying2044813companying
comparting17188383comparting
compassing1746553compassing
compeering1747053compeering
compile13312443compil__e
compiled1537813compil_ed
compiler1438373compil_er
compilers1537053compilers
compiles14311983compil_es
complain1448763complain_
complaining1844733complaining
complains1549193complains
complaint15410253complaint
completing1748423completing
complexing2444743complexing
compliant1549663compliant
complice1639333comp_lice
complied1539673comp_lied
complier14310253comp_lier
complies14314523comp_lies
complines15312833comp_lines
comporting17199163comporting
compositing1846263compositing
composting17178053composting
condoling13510373condoling
confiding1638333confiding
confining1539993confining
conniving1537093conniving
consoling12310873consoling
conspiring1546553conspiring
cooling103422573co__oling
coopering142611323coopering
cooping123918933coop__ing
coopting133411313coop_ting
coping113927663co_p__ing
coppering162810893coppering
copping143918593co_p_ping
copying153411983co_p_ying
corbeling1439033corbeling
cornicing1439043cornicing
couping124317023coup__ing
couplings1435543coup_lings
couponing1446293couponing
cowhiding1943843cowhiding
cowling134017423co__wling
cowriting1557323cowriting
crimpling1645343crimp_ling
crippling1644093crippling
crumpling1645323crump_ling
cupeling1338863c_upeling
cymbling1834773cym_bling
cymling1536273cym__ling
dimpling14199023dimp_ling
domiciling1643663domiciling
dumpling14217893dump_ling
emailing113010043_emailing
empaling1338363_empaling
foiling113317653fo__iling
hoppling16206763ho_ppling
impaling1338253_impaling
mailing102923343__mailing
moiling103417663__moiling
oiling74925313_o__iling
oompahing1773173oompahing
opining10311743_o_pining
piling95025593___piling
pommeling1643873pommeling
poppling12227323po_ppling
remailing122412473remailing
rimpling13219663rimp_ling
roiling83220453ro__iling
romping123113033romp__ing
rumpling13178763rump_ling
sampling13510643samp_ling
smiling103915443_sm_iling
soiling83422323so__iling
sopiting11310763so_piting
spiling102919703__spiling
toiling83219023to__iling
toppling13197353to_ppling
umpiring1336093_umpiring
unpiling1139753_unpiling
uppiling1335853_uppiling
vomiting1437733vom_iting
wimpling16207483wimp_ling

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411416.98321286.1
3Display Results1411410.0632238.1
 (SQL Overall)1786911417.46923924.4
 
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.