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

39 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
unbelievers165163(None) 
unbeliever1552401unbeliever_
believers14346632__believers
nonbelievers1751902nonbelievers
believer13448423__believer_
believes13449403__believe_s
disbelievers18111903disbelievers
misbelievers19112113misbelievers
nonbeliever1652233nonbeliever_
relievers12387063__relievers
unbeliefs1442943unbeli__efs
unbelieving1752263unbelieving
unrelieved1443513unrelieve_d
beliers94617384__beli__ers
believe12519774__believe__
believed14427924__believe_d
besiegers1244044__besiegers
delivers123310754__deli_vers
disbeliever17122304disbeliever_
disbelieves1782924disbelieve_s
misbeliever18122704misbeliever_
misbelieves18123104misbelieve_s
outdelivers1551764outdeli_vers
redelivers1443554redeli_vers
reliever11448684__reliever_
relieves114210394__relieve_s
umbellifers1851554umbellifers
unbelief1346774unbeli__e_f
unbelievable1952844unbelievable
unbelievably2262144unbelievably
unbeloved1543924unbel_ove_d
undeceives1643864undeceive_s
undelivered1652644undeli_vered
unlevels1143804un__l_evels
unlimbers1342584un__limbers
unlives102010954un__li_ve_s
unreelers9154744unre__elers
unreeves11106164unre__eve_s
unrelievedly1961234unrelievedly

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.423422437.4
2DLD Change Limit148819399.07616397.0
3Display Results39390.0162437.5
 (SQL Overall)178691399.51518779.9
 
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.