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

46 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
scolioses115561(None) 
scoliosis1144741scoliosis
conioses10313312_conioses
scolices1238732scoli_ces
scoliomas1342772scoliomas
calloses10313393_calloses
closes85425593_c_l_oses
coleuses1039723_coleuses
colies84837053_coli__es
colitises11311743_colitises
collinses1138283_collinses
colones96124433_col_ones
composes145017113_composes
coniosis1048133_coniosis
cosmoses1239703_cosmoses
coulisses1145633_coulisses
eclipses1244213ec_lipses
foliose10378013_foliose_
idolises938763idoli_ses
scabiosas1362613scabiosas
scabiouses1443003scabiouses
scaliness1149303scaliness
scariose1037593scariose_
schmooses16275633schmooses
scholiasts1544093scholiasts
sciolisms1346223scioli_sms
sciolists1147213scioli_sts
scleroses1146373scleroses
scoleces1237083scol_eces
scolioma1243383scolio_ma
scoliotic1345933scoliotic
scolloped1443653scolloped
scollops12235703scollo_ps
scorifies1448023scorifies
scouses93313243sco__uses
secaloses1146913secal_oses
semioses10611013s_emioses
silicoses1186183s_ilicoses
soleuses838073s_oleuses
solions7513753s_olio_ns
soloists869153s_oloists
sorboses1038523s_orboses
soroses73117483s_o_roses
spoliates1138543spoliates
stylises11188943styli_ses
symbioses1683553symbioses

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 Limit148641467.20320636.0
3Display Results46460.0331393.9
 (SQL Overall)178691467.67223291.3
 
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.