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

88 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
contrails1141054(None) 
contrail10410981contrail_
cantraips13255272cantraips
centrals102712032centra_ls
coattails1144852coattails
constrains1249722constrains
contains10316532cont_ains
contracts132212012contracts
contraries12711932contraries
contrarily1576102contrarily
contras93015622contra__s
contrasts112211042contrasts
controls10311392contr_ols
entrails8310162_entrails
monorails1148742monorails
bobtails1245193bobt_ails
cantals93919573cant_a_ls
cantraip12326393cantrai_p
cantraps12319113cantra_ps
cantrips12318933cantr_ips
cattails1038553c_attails
centals94317053cent_a_ls
central93114473centra_l_
centralise1269603centralise
centralism1448643centralism
centralist12511063centralist
centrally1448893centrally
centroids1247043centroids
citrals91111673c_itra_ls
coatracks1745403coatracks
coattail1045313coattail_
cocktails1744933cocktails
coistrils1146423coistr_ils
conceals123111013concea_ls
conepatls1385343conepatls
congeals11309853congea_ls
congrats11311433congra_ts
constrain1149333constrai_n
constraint12411133constraint
constraints1346203constraints
construals1245213construals
contacts123215213cont_acts
contain9315833cont_ai_n
contra83314703contra___
contrabass1453213contrabass
contract122915633contra_ct
contractile1547353contractile
contradict1556783contradict
contradicts1654583contradicts
contralti1147743contralti
contralto1147093contralto
contraltos1246763contraltos
contrarian1247933contrarian
contrarians1346353contrarians
contrarious1354733contrarious
contrary1347493contra_ry
contrast102614783contra_st
contrasty14217193contrasty
contrite10318543contr_ite
contrive13311353contr_ive
contrives14311703contrives
control9310693contr_ol_
corals85325143co__ra_ls
cornbraids1572983cornbraids
corrals93713853co_rra_ls
costrels1038933costr_els
countervails1755993countervails
countries11313613countr_ies
coveralls1447083coveralls
curtails10318243curt_ails
engrails945383_engrails
entails7912823_ent_ails
entrains8312963_entrains
fantails1139693fant_ails
foxtails1844583foxt_ails
handrails1346513handrails
horntails12124823hornt_ails
monorail1059773monorail_
nostrils848183nostr_ils
outsails8139863_outsails
oxtails1436383_oxt_ails
pintails10310163pint_ails
pontils9312213pont__ils
ponytails1443653ponytails
portraits1146803portraits
trails64622513___trails
ventails1139823vent_ails
ventrals112910003ventra_ls

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.436409841.7
2DLD Change Limit148641886.92021479.9
3Display Results88880.0332666.7
 (SQL Overall)178691887.38924183.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.