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

56 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
crucians124529(None) 
crucian1146281crucian_
brucins1158002bruci_ns
crucial1157892crucia_l
cruciate1287312cruciate
brechans1547413brechans
brucin1049133bruci_n_
brucine1138273bruci_ne
brucines1237763brucines
bruins86014953bru_i_ns
cancans11311873canc_ans
cautions103313183cautions
ceruleans1192923ceruleans
clachans1546413clachans
cocains111313923c_ocains
couchant1549053couchant
countians1147333countians
courlans10117613courlans
cousins9516003cousi_ns
cremains1238693cremains
cretins93216423creti_ns
croceins1238103croceins
crocine11314153croci_ne
cruces105117543cruc__es
crucially1645443crucially
crucible1445193crucible
crucibles1543743crucibles
crucifer1543683crucifer
crucifers1643333crucifers
crucifies1646123crucifies
crucifix2251843crucifix
crucify1744063cruci_fy
crucks144412583cruc__ks
crudites1137763crudites
cruises93514443cru_ises
cumins103314933c_umi_ns
currans9310613c_urrans
curtains10259703curtains
cutins83919983c_uti_ns
cyprians1544213cyprians
durians839573_durians
glucans1045293gluc_ans
grunions945353grunions
leucins938103leuci_ns
mucins102712513_muci_ns
orcins83313433or_ci_ns
radians83013823_radians
ricins83618703_rici_ns
ructions102811683_ructions
ruffians1443793_ruffians
ruins55822033_ru_i_ns
rupiahs1253333_rupiahs
rutins63818393_ruti_ns
saurians837763saurians
toucans937583touc_ans
trucing103211843truci_ng

Search took 7 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.403443402.0
2DLD Change Limit146162566.25023385.9
3Display Results56560.0331697.0
 (SQL Overall)178691566.68626726.1
 
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.