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

92 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
calcining144781(None) 
alining81917042_al_ining
cabining1338642ca_bining
calamining1545932calamining
calcifying2144492calcifying
calcimine1565412calcimine
calcimining1852452calcimining
alcidine1148233_alcidine
aliening91510893_aliening
aligning10158533_aligning
bylining1446013byl_ining
caching156317503ca_c_hing
cackling172610943ca_ckling
calcific1445023calcifi_c
calcified1746893calcified
calcifies1638923calcifies
calcimined1762973calcimined
calcimines1674683calcimines
calcine11315273calc__ine
calcined1338743calcin_ed
calcines12314753calcin_es
calcitic1148193calciti_c
calcitonin1453923calcitonin_
calcitonins1563433calcitonins
calking144617783cal__king
calling103826773cal__ling
callusing1236173callusing
calming123915973cal__ming
calorizing2248593calorizing
calquing2035593cal_quing
calving134113503cal__ving
canceling14310163canceling
caning94128623ca___ning
canning103620133ca__nning
cannoning1237323cannoning
cantoning12310883cantoning
canyoning1536873canyoning
capsizing2345833capsizing
captaining1546073captaining
captioning1545703captioning
careening12310013careening
cartoning12311113cartoning
cascading1545673cascading
catching163712773catc_hing
caucusing1443803caucusing
cautioning1345723cautioning
caverning1536283caverning
caviling14310113ca_viling
chagrining1743443chagrining
chaining142810783c_haining
chicaning1745153chicaning
chining133316843c__hining
clacking173313493clac_king
claiming13279303c_laiming
clarioning1345183clarioning
cleaning113112383c_leaning
clicking173610983c_licking
clinging122910913c_l_inging
clinking153611663c_l_inking
cloning103215473c_l_oning
clowning14307253c_lowning
coffining1845483coffining
coining103920543c__oining
cojoining1945753cojoining
colliding1338583colliding
combining1637893combining
confining1539993confining
cyclizing2645633cyclizing
declining13129353declining
eloining9310443_eloining
falconine1445173falconine
fulmining1554403fulmining
gaining94015663ga__ining
inclining1248403inclining
laicising1245623laicising
laicizing2145713laicizing
lining74526803__l_ining
machining1746933machining
maligning13145583maligning
margining1337603margining
paining103920243pa__ining
patining11312303pa_tining
plaining113911553_plaining
raining83922693ra__ining
ravining12269693ra_vining
reclining121112283reclining
relining93218743rel_ining
saining83621393sa__ining
sardining1137573sardining
splining11310773spl_ining
talcing103111633talc__ing
talcking1567083talc_king

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.1561145455.1
2DLD Change Limit148641927.65619415.0
3Display Results92920.0801150.0
 (SQL Overall)178691927.89222642.0
 
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.