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

62 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
civilise138626(None) 
civilised1584611civilised
civilises14106091civilises
civilize22106391civilize
civicism17105352civicism
civilian1344452civilian
civility1646122civility
civilized24105492civilized
civilizer23104322civilizer
civilizes23115882civilizes
divinise1267142divinise
canalise10816213canalise
cavelike1738213cavelike
caviling14310113caviling
cavils114014393cavil_s_
cavities131412613cavities
ceilis85413743c_eilis_
chilies124218303c_hilies
chilis115517873c_hilis_
cicelies1269753cicelies
cilice103213353c__ilice
citifies13310683citifies
civetlike1842703civetlike
civicisms18134823civicisms
civics13397823civi_cs_
civie103716353civ__i_e
civies114116443civi_es_
civil103411933civil___
civilians1443593civilians
civilising1644353civilising
civilities1547843civilities
civilizers24103123civilizers
civilly1535483civil_ly
civilness1444223civilness
civism1337243civ__ism
civisms1436073civisms_
civvies1555843civ_vies
creolise1037863creolise
criticise1356453criticise
cutinise1048763cutinise
devilish1546373devilish
divinised1465473divinised
divinises1367013divinises
divinize2197163divinize
divisive1545013divisive
divulse1134913divul_se
finalise113112573finalise
idolise839293_idolise
ivylike1734283_ivylike
minimise1246863minimise
mobilise1248143mobilise
nihilism1345193nihilism
nihilist1147163nihilist
novelise1137953novelise
rivulose1143363rivulose
trivialise1365163trivialise
utilise749063_utilise
valise92917643__valise
virilism1347273virilism
virilize2047743virilize
vitalise11310743vitalise
vivifies1747023vivifies

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.420425454.8
2DLD Change Limit146162626.42322756.0
3Display Results62620.0302066.7
 (SQL Overall)178691626.87325999.0
 
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.