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

122 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
flatcar127461(None) 
flatcap1463651flatcap
flatcars1344621flatcars
flancard1443372flancard
flatcaps1563402flatcaps
flatter103815962flatter
flatware1444882flatware
lascar868572_lascar
altar55520643al_t_ar
attar56516693__attar
avatar937523avat_ar
blather125314203blather
blatter94415653blatter
calcar10312753_calcar
clatter94014973clatter
elater64724203elat_er
facer105525053f_a_cer
factor11911453f_actor
faecal11359813f_aecal
falter94519053falt_er
farcer115016083f_arcer
fatal84819373f_at_al
father125116713f_ather
fatter94523213f_atter
fatwa1168063f_atwa_
fatwas1249053f_atwas
faucal11339963f_aucal
feater95224053feat_er
feather133613503feather
flaccid1544393flaccid
flack144519413fla_c_k
flacks154114533fla_cks
flacon1138633fla_con
flagger12469353flagger
flagman13186173flagman
flair86114123fla__ir
flaker134916173fla_ker
flakier143910203flakier
flamer114919123fla_mer
flamier123112143flamier
flancards1543183flancards
flaneur1034183flaneur
flanger113412623flanger
flanker143911293flanker
flapper14359203flapper
flashcard1842043flashcard
flasher133914063flasher
flat77147823flat___
flatbed13397983flatbed
flatboat1346473flatboat
flathead1535803flathead
flatland1264963flatland
flatlet10312253flatlet
flatly123110213flat_ly
flatmate1346393flatmate
flats86429743flat__s
flatted114012943flatted
flatten10429653flatten
flatters113814203flatters
flattery14338293flattery
flattop1244403flattop
flatus94310783flat_us
flatwares1544763flatwares
flatwash1742423flatwash
flatways1744323flatways
flatwork1845393flatwork
flatworm1645183flatworm
flauta937823flauta_
flautas1036153flautas
flavor1236663fla_vor
flavour1334633flavour
flawier13378733flawier
flaxier17337983flaxier
flayer124713563fla_yer
fleecer12368033fleecer
fletch14388193fletc_h
fletcher16306663fletcher
flitch14928173flitc_h
flitter103413903flitter
floater104413353float_er
floatier1136983floatier
flota85315643flot_a_
flotas94013003flot_as
flotsam1244623flotsam
fluter95316863flut_er
flutier103011553flutier
flutter104012093flutter
flytier13356503flytier
flytrap1543253flytrap
fracas11311993fra_cas
fractal1237623fractal
fractur12135563fractur
frater94520593frat_er
glancer103710073glancer
klatch15445933klatc_h
lacer75833753_la_cer
lactam10310943_lactam
lactary1237843_lactary
lahar83114263_la_har
laical8312323_laical
lancer84319973_lancer
lascars979013_lascars
latch104620463_latc_h
later54843923_lat_er
lather95124353_lather
latter65027893_latter
lazar144113643_la_zar
placard1236783pla_card
placer105117743pla_cer
planar84212713pla_nar
plantar9369993plantar
platan83913693plat_an
plateau937403plateau
plater84427693plat_er
platier93716293platier
platter93917413platter
slatch114510533slatc_h
slater64429183slat_er
slather103816073slather
slatier74016813slatier
tatar56122063_tat_ar
tramcar1135593tramcar

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 Limit1340271225.94022563.5
3Display Results1221220.0602033.3
 (SQL Overall)1786911226.40327907.4
 
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.