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

185 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
gilbert1031076(None) 
filbert12411641filbert
gilberts1134181gilberts
filberts1334992filberts
gibber114112862gibber_
gibbers124710982gibbers
gibbet114113382gibbe_t
giber85417702gi_ber_
gibers95114662gi_bers
giblet93418892gible_t
gilder84415532gilder_
gilders94212462gilders
giller74519732giller_
gillers84216902gillers
halbert12314502halbert
ailment9314233ailment
albeit8314343_albeit
alert54740663_al_ert
bibber94613573bibber_
bibbers103911353bibbers
bibbery13426543bibbery
bilberry1543283bilberry
bilker124913443bilker_
bilkers134711863bilkers
biller84923483biller_
billers94720833billers
billet86029723bille_t
culvert123011773culvert
dibber114614713dibber_
dibbers124013173dibbers
diluent8310263diluent
dissert83720693dissert
divert103922813di_vert
fibber134811933fibber_
fibbers144510603fibbers
fiber104921133fi_ber_
fibers114717523fi_bers
filer85433003fil_er_
filers94623723fil_ers
filet85540163fil_e_t
filler94623623filler_
fillers104320213fillers
fillet95027083fille_t
filmer114112403filmer_
filmers124211293filmers
filter94517633filter_
filters103816553filters
gabbart1248883gabbart
gabber114916603gabber_
gabbers124612833gabbers
galere73716693gal_ere
gallery11468743gallery
gallet73630853galle_t
gelder84613713gelder_
gelders93812573gelders
gerbera1034773gerbera
gibbed124512353gibbe_d
gibbered1444303gibbered
gibbets12417723gibbets
gibe75927793gi_be__
gibed96215963gi_be_d
gibes84422523gi_be_s
giblets103210423giblets
giglet83920273gigle_t
gilded94413223gilde_d
gilled84521633gille_d
gillnet839733gillnet
gilt56348553gil___t
gimlet93716663gimle_t
ginger84920033ginger_
gingers94118643gingers
gingery12368913gingery
ginner73915823ginner_
ginners84314223ginners
gipper114215303gipper_
gippers123212083gippers
girder84312063girder_
girders9379943girders
girlier8289523girlier_
girliest93010403girliest
girt56646433gi___rt
gittern8337503gittern
giver94921203gi_ver_
givers104817713gi_vers
gleet65532343g_l_eet
glibber1235163glibber_
glibbest1343683glibbest
glider84614263glider_
gliders94811843gliders
gluer65116773g_luer_
gluers75011153g_luers
gobbet114214443gobbe_t
goblet93219483goble_t
golder84417603golder_
goldest92411173goldest
golfer104411183golfer_
golfers114410083golfers
goober93911743goober_
goobers10219623goobers
griller84513353griller_
grillers93810813grillers
grillery12355503grillery
guilder945913guilder_
guilders1035513guilders
gullet74924833gulle_t
gulper93410213gulper_
gulpers10299013gulpers
halberd1336053halberd
halberts1335973halberts
hiller94421633hiller_
hillers103718733hillers
iller54821293_iller_
illest63615723_illest
inert53234373_i_nert
insert64325253_insert
invert94120083_invert
jibber174111243jibber_
jibbers18449703jibbers
jiber145115703ji_ber_
jibers155912883ji_bers
jilter133512513jilter_
jilters144211963jilters
killer104917953killer_
killers114215583killers
kilter103714343kilter_
kilters113813603kilters
lambert113617113lambert
libber104414013libber_
libbers113812833libbers
liber74723623li_ber_
libers84721443li_bers
liberty1237163li_berty
limber104316793limber_
limbers113614743limbers
milder93818453milder_
mildest102812063mildest
miler75733063mil_er_
milers84625163mil_ers
milker124814323milker_
milkers134411613milkers
miller84625413miller_
millers93621343millers
millet84030743mille_t
milter84921233milter_
milters93619093milters
oilbird1043743oilbird
oiler54628283oil_er_
oilers64721193oil_ers
oilier64417233oilier_
oiliest72817683oiliest
pilfer1139163pilfer_
pilfers1238963pilfers
ribber103515493ribber_
ribbers113913183ribbers
riblet84222443rible_t
rillet64828853rille_t
sievert10613293sievert
silent64125843sil_ent
siller64026063siller_
sillers73822103sillers
silver93815813silver_
silvern10347143silvern
silvers104714043silvers
silvery13328093silvery
tilbury1242983tilbury
tiler56131023til_er_
tilers63523503til_ers
tiller64222543tiller_
tillers73418743tillers
tilter63417693tilter_
tilters73315953tilters
timber104012683timber_
timbers113111853timbers
timbery14256893timbery
viler86324163vil_er_
vilest9416843vil_est
wilder103616473wilder_
wilders113513503wilders
wildest113311273wildest
wilier93217073wilier_
wiliest103416593wiliest
willer94021063willer_
willers103517913willers
willet95124833wille_t
zibet16419733zi_be_t

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.390458182.1
2DLD Change Limit1340271856.40620922.1
3Display Results1851850.0632936.5
 (SQL Overall)1786911856.85926052.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.