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 “fleapit” 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
fleapit125599(None) 
fleapits1363251fleapits
fleabite1354162fleabite
leapt75027472_leap_t
beleapt11310253beleap_t
bleat75737003blea__t
cheapie1437563cheapie
clapt98027173cl_ap_t
cleat76335063clea__t
clept95725773cle_p_t
elapid939543el_apid
elegit71212893ele_git
feast85932723f_ea_st
feat76458223f_ea__t
flail85316183fl_a_il
flair86114123fl_a_ir
flap96128703fl_ap__
flappy1654483fl_appy
flaps105621383fl_ap_s
flat77147823fl_a__t
flaunt9712913fl_aunt
flavin1239303fl_avin
flea75628493flea___
fleabag1342923fleabag
fleabites1443613fleabites
fleam106017283flea__m
fleams115011943flea_ms
fleas86423663flea__s
fleawort1447023fleawort
fleet85932333fle__et
fleshpot1643843fleshpot
flit76539273fl___it
float85928573floa__t
floruit1047293floruit
flypast1583753flypast
klepht1535043kle_pht
lapin75222923_l_apin
lapis76223153_l_apis
leant56737783_lea_nt
leap66032683_leap__
leaped94317773_leaped
leaper88118943_leaper
leaping103215993_leaping
leaps75522933_leap_s
learnt64019253_learnt
least56134883_lea_st
legit61323503_le_git
lept66440883_le_p_t
plait75631573pl_a_it
pleat74734473plea__t
skelpit1344943skelpit
sleekit1145453sleekit
slept75728103sle_p_t
teapot8416763_teapot
upleapt11116863upleap_t

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 Filter1786911340270.423422437.4
2DLD Change Limit134027556.75019855.9
3Display Results55550.0301833.3
 (SQL Overall)178691557.20324807.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.