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

61 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
civilness144422(None) 
civilises14106092civilises
civilnesses1644852civilnesses
evilness1135042_evilness
lividness1344712lividness
vividness1643932vividness
airiness8412213airi_ness
avidness1246113_avidness
caginess11310303cagi_ness
cakiness1449553caki_ness
cavilers1348113cavil_ers
cavillers1435613cavillers
chicness1535593c_hicness
chilliness1555313chilliness
chillness1455373chillness
chinless1337493c_hinless
citizeness21124653citizeness
civies114116443civi__e_s
civilians1443593civilians
civilise1386263civil_ise
civilised1584613civilised
civilizers24103123civilizers
civilizes23115883civilizes
coolness1037743c_oolness
cosiness103214283cosi_ness
coziness19319823cozi_ness
cruelness1145053cruelness
curliness1138553curliness
diviners12308353divi_ners
divines113514723divi_ne_s
divinest123012173divi_nest
frailness1236543frailness
hilliness1248923hilliness
hiveless14227933hivel_ess
iciness938863_ici_ness
ickiness1436753icki_ness
illness736473_i_llness
levelness1245453levelness
licitness1145373licitness
liminess10510643limi_ness
liveliness1345633liveliness
liveness112411393liv_eness
livingness1443343livingness
miriness10310463miri_ness
oiliness8311563oili_ness
ovalness1134673_ovalness
pipiness1238003pipi_ness
pitiless10127333pitil_ess
pixiness1736093pixi_ness
rigidness1145123rigidness
riminess10510093rimi_ness
silliness9510363silliness
siziness1737423sizi_ness
tidiness938793tidi_ness
timidness1244623timidness
tininess8310633tini_ness
vileness1139983__vileness
vitalness1245413vitalness
waviness1437723wavi_ness
wiliness1139113wili_ness
wiriness1138953wiri_ness

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.1731032896.0
2DLD Change Limit148641617.53019739.8
3Display Results61610.0163812.5
 (SQL Overall)178691617.71923149.5
 
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.