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

130 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
consults1021998(None) 
consuls92412311consul_s
consult92513631consult_
conducts13118712conducts
conduits111210062conduits
consents102715892consents
consists10310592consists
consoles103216152consoles
consols92914072consol_s
consorts101512342consorts
consul82312302consul__
consular1038812consular
consulate11612232consulate
consulates12711102consulates
consulted1277922consulted
consulter1198222consulter
consulters1297212consulters
consultor1176472consultor
consultors1286402consultors
consumes12310412consumes
insults7268962_insults
nonsuits869152nonsuits
reconsults1244022reconsults
canfuls1248423canful_s
cannulas1037583cannulas
canulas9312853can_ulas
capsules1236623capsules
catsuits1045433catsuits
censures102211623censures
census84310303censu__s
censuses10187543censuses
coasts85719143coas__ts
cobalts1139203co_balts
cobnuts1135353cobnu_ts
coinsures1136723coinsures
colts76633293co___lts
combusts1445493combusts
conceits122813613conceits
concents122516603concents
concepts143110303concepts
concerts123016063concerts
concocts1138633concocts
concurs11311473concu_rs
concuss1138063concu_ss
condoles113015803condoles
conduces13129783conduces
conduct121411593conduct_
conduit10713083conduit_
condyles14277463condyles
confects153110873confects
confits122811423con_fits
confuses13310363confuses
confute1239263confu_te
confutes1339843confutes
congests113510383congests
congrats11311433congrats
coniums11311863coniu_ms
conjuncts2043653conjuncts
conjunto1744653conjunto
conjuntos1844373conjuntos
conjures17119913conjures
connects123010563connects
conquers1938223conquers
conquest1939553conquest
conquests2045363conquests
consent93723113consent_
consigns1137533consigns
consist9316033consist_
consol82614113consol__
console92715983consol_e
consoled112911443consoled
consoler102812613consoler
consolers112510923consolers
consort91319903consort_
constants11410913constants
constructs1457053constructs
consultant1246703consultant
consultants1354683consultants
consulting1349083consulting
consultive1546673consultive
consume11510133consu_me
consumed1337923consumed
consumer1238503consumer
consumers1337203consumers
contacts123215213contacts
contents104018213contents
contests103413383contests
contexts17378653contexts
contorts101112643contorts
contuses10413453contuses
conus76726533con_u__s
convects153410993convects
convents132614603convents
converts133213553converts
convicts15337713convicts
convulse1345443convulse
convulses1445503convulses
copouts11311083copou_ts
copulas113811563co_pulas
coquets18399893co_quets
corrupts1244983corrupts
corselets1147313corselets
corsets94819803cors_ets
corslets1038273corslets
cosets85824403co_s_ets
cossets95014283co_ssets
costs77231143co_s__ts
coulis84018763co__ulis
counsels1037573counsel_s
counts84618273co__unts
courts84216173co__urts
cults75022553c___ults
donuts7410583don_u_ts
indults8289493_indults
insult62813673_insult_
moults84713703mo__ults
nonadults1043523nonadults
nonguilts1044103nonguilts
nonsuit7811343nonsuit_
occults1135123_occults
onsets64013543_ons_ets
penults937123pen_ults
poults84613483po__ults
reconsult1145673reconsult_
results739833_results
sunsuits845963sunsuits
tonsils7310183tonsil_s
tonsures869133tonsures
zonulas1637023zon_ulas
zonules1647793zon_ules

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621308.26617682.3
3Display Results1301300.0462826.1
 (SQL Overall)1786911308.46821101.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.