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

84 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
flattop124440(None) 
flattops1344551flattops
flatcap1463652flatcap
flatted114012942flatted
flatten10429652flatten
flatter103815962flatter
laptop1076812_laptop
alastor739653alastor
alation72920553alation
anatto6139913anatto_
anattos7138453anattos
atop66124753__a_top
blacktop1842973blacktop
blatted104812713blatted
blatter94415653blatter
blotto8198443blotto_
caltrop11267643caltrop
cartop104213563_cartop
clatter94014973clatter
datto65416423_datto_
dattos74311903_dattos
elation73620453elation
factor11911453f_actor
fantod102010033f_antod
fantom112110803f_antom
fathom1437473f_athom
fatso85113493f_atso_
fatsos9389423f_atsos
fatted105419843f_atted
fatten94314903f_atten
fatter94523213f_atter
fatty115117413f_att_y
flacon1138633fla_con
flagon1037983fla_gon
flap96128703fla___p
flareup1243173flareup
flat77147823fla_t__
flatbed13397983flatbed
flatboat1346473flatboat
flatcaps1563403flatcaps
flatcar1274613flatcar
flatfoot1445293flatfoot
flatiron1144623flatiron
flatlet10312253flatlet
flatlong12274523flatlong
flatly123110213fla_tly
flats86429743fla_t_s
flattens11357483flattens
flatters113814203flatters
flattery14338293flattery
flattest1138713flattest
flatting123511253flatting
flattish1455263flattish
flatus94310783fla_tus
flatwork1845393flatwork
flatworm1645173flatworm
flauta937823flaut_a
flautas1036153flautas
flavor1236663fla_vor
flitted114011643flitted
flitter103413903flitter
flop96925453fl___op
flutter104012093flutter
flytrap1543253flytrap
foretop12117893foretop
glutton844893glutton
laptops1166603_laptops
latte55426303_latt_e
latten65018203_latten
latter65027893_latter
lattes65324203_lattes
lattin64316223_lattin
lotto55217573_lotto_
lottos64613103_lottos
mulatto944733mulatto_
mulattos1044083mulattos
palmtop1343873palmtop
platoon938953platoon
platted103614263platted
platter93917413platter
ragtop936683_ragtop
ratton64116123_ratton
slatted84015183slatted
tattoo6310973_tattoo

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.1561145455.1
2DLD Change Limit134027846.59320328.7
3Display Results84840.0302800.0
 (SQL Overall)178691846.77926359.5
 
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.