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

86 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
consulting134908(None) 
conducting1648832conducting
confuting1539092confu_ting
consenting13313212consenting
consisting1349522consisting
consoling12310872consol_ing
consorting13410742consorting
consultant1246702consultant
consultive1546672consultive
consuming1437912consu_ming
convulsing1645382convulsing
insulting1038052_insulting
nonsuiting1147272nonsuiting
reconsulting1554212reconsulting
cannulating1446003cannulating
canulating1349543can_ulating
capsuling1444533capsul_ing
censuring1237603censu_ring
censusing1244813censu_sing
coagulating1545073coagulating
coasting113615513coas__ting
coequating2245323coequating
coinsuring1345373coinsu_ring
combusting1745443combusting
commuting16288443commu_ting
computing16309853compu_ting
conceiting15311773conceiting
concerting15313893concerting
concluding1644913concluding
concocting1448413concocting
concreting1539873concreting
concurring1546603concurring
concussing1546143concussing
condoling13510373condol_ing
conducing1537693condu_cing
confecting18310553confecting
conflating16410003conflating
confusing1537333confu_sing
congesting14410113congesting
conjugating2244503conjugating
conjuring1937913conju_ring
connecting15310383connecting
connoting12310023con_noting
conquering2246273conquering
conserving1639753conserving
consigning1446783consigning
conspiring1546553conspiring
constructing1746753constructing
construing1347443construing
consult92513633consult___
consultancy1853053consultancy
consultants1354683consultants
consulted1277923consult_ed
consulter1198223consult_er
consulters1297213consulters
consultor1176473consult_or
consultors1286403consultors
consults10219983consult__s
consummating1953663consummating
contacting15610073contacting
contenting13313323contenting
contesting13312213contesting
contorting13410103contorting
contusing1239143contu_sing
convecting18310433convecting
conventing16311543conventing
converting16313133converting
convicting1847583convicting
convoluting1744203convoluting
convolving1944413convolving
copulating1549373co_pulating
corrupting1555583corrupting
corseting12312173cors_eting
cosseting1239543co_sseting
costing104323023co_s__ting
counseling1345463counsel_ing
counselling1444403counselling
counting113115273co__unting
courting112514573co__urting
insulating1139263_insulating
moulting112710313mo__ulting
nonhunting1444683nonhunting
nonruling1046433nonrul_ing
occulting1445103_occulting
resulting10311083_resulting
tonsuring1046503tonsu_ring

Search took 10 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 Filter1786911406030.1561145455.1
2DLD Change Limit140603868.95315704.6
3Display Results86860.0461869.6
 (SQL Overall)178691869.15519518.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.