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

146 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
combust133836(None) 
combusts1445501combusts
bombast1348222bombast
cambist13312112cambist
combat12316752comb_at
combats13311682combats
combes125321732combes_
combos125316612combos_
combs116122962comb_s_
combusted1644642combusted
combustor1543702combustor
comous10816502comous_
compost134515352compost
kombus1435522kombus_
robust8310432ro_bust
ambush1336113_ambush
bombasts1444953bombasts
bombes124916823bombes_
bomblet13412263bomblet
bombs115818823bomb_s_
bust65947783___bust
cambism1538033cambism
cambists1437023cambists
campus125213923campus_
coast75236273co__ast
cobalt10317393co_balt
cobbiest14118523cobbiest
cobbs115013993co_bbs_
cobnut10311323co_bnut
cobnuts1135353cobnuts
cobs87043143co_b_s_
coccus979283coccus_
coexist1638583coexist
cohost115217213co_host
coitus8511893coitus_
colbys13407153colbys_
coldest102514763coldest
coleus86818273coleus_
colobus11389373colobus_
comas95833003com_as_
comb106632113comb___
combe116223543comb__e
combed135516543comb_ed
comber125118503comb_er
combers134516623combers
combine133014723combine
combing143714733combing
combo114519433comb__o
combusting1745453combusting
combustion1644563combustion
combustive1953753combustive
combustors1643753combustors
comers105328083comers_
comes97246993com_es_
comet95946073com__et
comets105823583comets_
comfiest1539133comfiest
comfit133112423com_fit
comfits14328743comfits
comfort143611693comfort
comics124015563comics_
commas124814573commas_
comment1310317703comment
commit124016703com_mit
commits133812383commits
commixt20357623commixt
commune13329363commune
communist1548113communist
commute134310443commute
comose105016843com_ose
compact153712213compact
compart134016003compart
compas125817063compas_
compass13379563compass
complot13310683complot
comport133616843comport
compos124818803compos_
compose135716663compose
composts144210913composts
comps115526053com_ps_
compt116328223com__pt
compts125216653compts_
compute134513663compute
computist1547323computist
comtes106222813comtes_
concuss1138063concuss
conduct121411593conduct
conduit10713083conduit
confuse1238853confuse
congest104618773congest
conquest1939553conquest
consist9316033consist
consult92513633consult
contest93523233contest
contuse9311413contuse
conus76726533co_nus_
coolest9318643coolest
coombes133810663coombes_
coombs124210193coomb_s_
copout10418783copou_t
copouts11311083copouts
copyist1439053copyist
coquet174318013co_quet
cormous11312353cormous_
cornus84816563cornus_
corpus106015293corpus_
corrupt1149103corrupt
cosiest93819853cosiest
cosmist11311333cosmist
cost68057943co___st
couldst1037043couldst
count74932053co__unt
court75532773co__urt
cowiest123614673cowiest
coyest11316053co_yest
coypus13389303coypus_
coziest184014353coziest
crust75827663c__rust
cubist104214443c_ubist
cumquat2044513cumquat
cymous1388403cymous_
dumbest1238743dumbest
gombos114311093gombos_
homburg1543073homburg
homiest124116633homiest
iambus10468903iambus_
joust125122293jo__ust
kombu1347243kombu__
lambast11129893lambast
limbus105710383limbus_
locust85312343lo_cust
momus96116113mom_us_
must65145443__m_ust
nimbus10377283nimbus_
numbest1138793numbest
oust46747443_o__ust
rhombus14243893rhombus_
robusta944283ro_busta
romaunt947803romaunt
roust55532063ro__ust
tombs97818733tomb_s_
wombat1339863womb_at
wombats1435893wombats
wombiest1536893wombiest
wombs125813343womb_s_
zombis1936283zombis_

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.390458182.1
2DLD Change Limit1340271466.67320085.0
3Display Results1461460.0433395.3
 (SQL Overall)1786911467.10625146.5
 
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.