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

55 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
nombril114510(None) 
nombrils1244511nombrils
gomeril1047382gomeril
nostril749302nostril
tumbril11256402tumbril
cambric1537393cambric
corbeil11859213corbeil
domicil1246433domicil
embroil1146613_embroil
fibril1137163_fibril
fimbria1444453fimbria
fimbrial1544193fimbrial
gambrel1235453gambrel
gomeral1038833gomeral
gomerel1036393gomerel
gomerils1146793gomerils
gumboil1244373gumboil
hombre13309303hombr_e
hombres14369873hombres
homeric14312213homeric
nimbi94910313nimb_i_
nitril62511533n_itril
nobbily1436693no_bbily
noil46133243no___il
nomadic1248033nomadic
nomarch1445353nomarch
nombles113212343nombles
nominal92712373nominal
nomoi76012533nom_oi_
nondrip1046233nondrip
nonmoral1049233nonmoral
nonoral7313603nonoral
nori47133143no__ri_
noria55722183no__ria
noris54928273no__ris
nostrils848183nostrils
notarial8410753notarial
numeral939083numeral
numeric1158193numeric
ombre94111803_ombr_e
ombres103911143_ombres
potboil1195463potboil
scombrid1543373scombrid
sombre10729473sombr_e
sombrely1543703sombrely
timbral11237193timbral
timbrel11306563timbrel
tombal102311023tomb_al
tumbrel11406853tumbrel
tumbrils12255373tumbrils
umbral1038633_umbral
zombi1838993zomb_i_
zombie1937323zomb_ie
zombis1936283zomb_is
zoril143916693zo__ril

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 Filter1786911340270.403443402.0
2DLD Change Limit134027556.09621986.1
3Display Results55550.0134230.8
 (SQL Overall)178691556.51227440.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.