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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
cellule93652(None) 
cellules1036811cellules
cellae84915932cell_ae
cellular1045162cellular
cellulase1143872cellulase
cellulite11114872cellulite
cellulose1143652cellulose
collude10337982collude
acellular1143043acellular
allele64514563_allele
allude73910903_allude
allure63012943_allure
ballute938543ballute
belle75827833be_l_le
bellpull1241813bellpull
calculi1146553calculi
calicle113111433calicle
callable12310753callable
callee84327293call_ee
callose9313653callose
callus85317073callu_s
callused1135853callused
calluses1039323calluses
calque17289843calqu_e
calycle14245833calycle
capsule1137343capsule
cedula977643ce_dula
celeste949653celeste
cell65031723ce_l_l_
cella75420313ce_l_la
cellar84514983cell_ar
cellared11398793cellared
cellarer10317923cellarer
cellaret103713573cellaret
cellars93713693cellars
celled94420323cell_ed
celli76717693ce_l_li
celling103921263celling
cellist9314423cellist
cellmate1237863cellmate
cello74919583ce_l_lo
cellos84517803cell_os
cells75428063ce_l_ls
cellulars1144133cellulars
cellulases1243553cellulases
cellulites1294433cellulites
celluloid1253373celluloid
celluloses1243643celluloses
cellulous1144353cellulous
cenacle1139123cenacle
censure92310603censure
centile94217183centile
centuple12164043centuple
ceruse83914523ce_ruse
ciboule1145093ciboule
clause84311503c_lause
clue65324533c__lu_e
collage102813753collage
collate92919683collate
college102410433college
collide103214783collide
collie83621993coll_ie
colluded12296453colluded
colluder11276863colluder
colludes11279213colludes
colure8314153c_olure
culture939393culture
cupule103410723c_upule
curule83614123c_urule
delouse839833delouse
delude81910673de_lude
deluge8189403de_luge
deluxe14197303de_luxe
deplume1255063deplume
eellike1138233eellike
elude64517623_e_lude
elute54822573_e_lute
fellable13179133fellable
fellate10313433fellate
felloe93513923fell_oe
ferrule1035863ferrule
ferule93413203fe_rule
gelable101710733gelable
gemmule12173233gemmule
hellhole1445243hellhole
helluva1353533helluva
illude7327503_illude
illume8298223_illume
nebule848753ne_bule
nellie63614813nell_ie
nervule1044943nervule
ocellate1037863ocellate
ocellus935983ocellu_s
pellicle1245043pellicle
pilule8411123_pilule
pollute937383pollute
recluse95210773recluse
reglue739703reglu_e
relume8313273re_lume
seclude1035233seclude
sellable101711823sellable
selle54428313se_l_le
tellable10169773tellable
telltale844423telltale
umbellule1351993umbellule
valvule1343663valvule
veinule1056243veinule
vellum1136773vellu_m
vellums1235293vellums
veloute1037733veloute
velure939773ve_lure
venule94411763ve_nule
wellhole1444203wellhole
wellie92814913well_ie

Search took 9 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.1701051123.5
2DLD Change Limit1340271148.31316122.6
3Display Results1141140.0462478.3
 (SQL Overall)1786911148.52920951.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.