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 “centillions” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
centillions135397(None) 
centillion1254461centillion_
cotillions1244782c_otillions
septillions1352722septillions
sextillions1852352sextillions
cantillations1545733cantillations
centurions1255513cent_urions
cotillion1145283c_otillion_
cotillons1144653c_otill_ons
decillions1345433de_cillions
dentitions1148853denti_tions
nonillions1045263non_illions
octillions1243613_octillions
postillions1354553postillions
quintillions2152313quintillions
septillion1263143septillion_
sextillion1752853sextillion_
ventilations1547403ventilations
vermillions1652723vermillions
anthelions1345494_anthelions
antlions839194_ant__lions
bazillions2143094_bazillions
billions102211794___billions
cantillates1346634cantillates
cantillation1446694cantillation_
carillons1146364c_arill_ons
centerline1247044centerli_ne
centerlines1346994centerlines
centiles103615814centi_l__es
centiliter1245654centi_liter
centiliters1343914centiliters
centimos12507324centi__mo_s
centralises1349294centralises
centralisms1547404centralisms
centralists1348144centralists
centralizes2249424centralizes
centupling1543014centupli_ng
centurion1165884cent_urion_
concisions1448244conci_sions
conditions13410104condi_tions
conniptions1546034conniptions
contagions1346604cont_agions
contentions13412094contentions
contortions1348684contortions
contritions13410914contritions
contusions1246994cont_usions
convictions1848044convictions
convulsions1644314convulsions
cotillon1045054c_otill_on_
cullions10219224c___ullions
decillion1245834de_cillion_
dentations11413634dent_ations
dentition1049634denti_tion_
entitling1037104_entitli_ng
entropions12105744_entropions
envisions1245614_envi_sions
fenthions1544234fent__hions
gazillions2042704_gazillions
hellions11310024he___llions
jillions15178284___jillions
kazillions2352514_kazillions
lenitions939474len_i_tions
medaillons1352354medaill_ons
medallions1343264me_dallions
mentations12312584ment_ations
mentions10312894ment___ions
millions101712434___millions
modillions1343684_modillions
nonillion945464non_illion_
octillion1144174_octillion_
pencilling1545474pencilli_ng
pencillings1652404pencillings
penicillins1553344penicilli_ns
petitions11511084pe_ti_tions
pillions101610924___pillions
postilions12116284posti_lions
postillion1255634postillion_
quintillion2052654quintillion_
rebellions1244204re_bellions
renditions1149184rendi_tions
reptilians1243684repti_lians
scintillations1662754scintillations
semillons1145094se_mill_ons
stallions946074__stallions
trillions947184__trillions
vanillins1245544van_illi_ns
venditions1445524vendi_tions
ventilation1448164ventilation_
ventilators14105064ventilators
vermilions1543874vermi_lions
vermillion1553254vermillion_
vigintillions1771064vigintillions
zillions17168074___zillions

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 Filter1786911488190.420425454.8
2DLD Change Limit148819938.84316829.0
3Display Results93930.0501860.0
 (SQL Overall)178691939.31319187.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.